<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询数据库</title>
<style type="text/css">
h1 {
	color: red;
}
</style>
</head>
<body>
	<h1>显示成语数据库的前7条记录</h1>
	<%
	Class.forName("com.mysql.cj.jdbc.Driver");
	try (Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "12qwas");
			Statement stat = cn.createStatement()) {
		try (ResultSet rs = stat.executeQuery("select cy as chyu from chengyu limit 7")) {
			while (rs.next()) {
		//String cy=rs.getString(1);
		String cy = rs.getString("chyu");
		out.println("<p>" + cy + "</p>");
			}
		}
	}
	%>

</body>
</html>